package com.intelligent.mapper;

import com.intelligent.pojo.ProductionMaterialRequisition;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;

import java.util.Map;

/**
* @author lenovo
* @description 针对表【production_material_requisition(生产领料表)】的数据库操作Mapper
* @createDate 2025-09-07 20:38:29
* @Entity com.intelligent.pojo.ProductionMaterialRequisition
*/
public interface ProductionMaterialRequisitionMapper extends BaseMapper<ProductionMaterialRequisition> {
    IPage<Map<String, Object>> selectPageWithJoin(
            Page<Map<String, Object>> page,
            @Param("requisitionNo") String requisitionNo,
            @Param("approvalStatus") Integer approvalStatus,
            @Param("productionWorkOrder") String productionWorkOrder,
            @Param("username") String username,
            @Param("warehouseReceipt") String warehouseReceipt,
            @Param("startDate") String startDate,
            @Param("endDate") String endDate
    );

    Map<String, Object> selectDetailById(@Param("id") Long id);

    int insertOne(ProductionMaterialRequisition entity);

    int updateOne(ProductionMaterialRequisition entity);

    int deleteOne(@Param("id") Long id);
}




